Excel Grand Wizards - need assistance
I have two columns of drop downs and I would like to make the second column conditional to what is selected in the first column. For example in Column A if I select Value 1, only A,B or C are available to select in column B. If I select Value 2, only D, E or F are available to select. I haven't figured it out. Do I need to write a macro? Any other suggestion? Will provide a tip. Thanks.
[Post edited by Technocrat at 06/28/2017 09:05AM]
|
Posted: 06/28/2017 at 09:00AM